home *** CD-ROM | disk | FTP | other *** search
/ Belgian Amiga Club - ADF Collection / BS1 part 43.zip / Superbase pro 2.1 disk 2.adf / Interest Accrued.sbq < prev    next >
Text File  |  1987-12-09  |  322b  |  12 lines
  1. SB
  2. Clients
  3. Accounts
  4. Deposits
  5.  
  6. DP
  7. Interest Accrued on Deposits
  8. Firstname.Clients,Lastname.Clients,Account,Amount,&8Interest, FIX (Amount * (Interest / 100) * ( TODAY - Date) / 365,2) AS "  Accrued"
  9. GROUP Lastname.Clients SUM "  Accrued"
  10. Lastname.Clients = Lastname.Deposits AND Bank Name = Bank
  11. Lastname.Clients
  12.